import javax.swing.*;
import java.awt.event.*;
import java.sql.*;

public class Login
{
	Connection con;
	Statement st;
	ResultSet rs;
	
	JFrame f = new JFrame("User Login");
	JLabel a = new JLabel("Username:");
	JLabel aa= new JLabel("Password:");
	JTextField t = new JTextField(10);
	JTextField t1 = new JTextField(10);
	JButton b = new JButton("Login");
	
	public Login()
	{
		connect();
		frame();
	}
	
	public void connect()
	{
		try
		{
		String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
		Class.forName(driver);
		
		String db = "jdbc:odbc:table2";
		con = DriverManager.getConnection(db);
		st = con.createStatement();
		}
		catch(Exception ex)
		{
		}
	}
	
	public void frame()
	{
		f.setSize(600,400);
		f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);;
		f.setVisible(true);
		
		JPanel p = new JPanel();
		p.add(a);
		p.add(t);
		p.add(aa);
		p.add(t1);
		p.add(b);
		
		f.add(p);
		
		b.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent e)
			{
				try
				{
					String user = t.getText().trim();
					String pass = t1.getText().trim();
				
					String sql = "select user,pass from table2 where user ='"+user+"'and pass ='"+pass+"'";
				
					rs = st.executeQuery(sql);
					int count = 0;
					while(rs.next())
					{
						count = count +1;
					}
				
					if(count == 1)
					{
						JOptionPane.showMessageDialog(null, "User Found , Access Granted");
					}
					else if(count > 1)
					{
						JOptionPane.showMessageDialog(null,"Duplicate User , Access Denied");
					}
					else
					{
						JOptionPane.showMessageDialog(null,"User does not Exist ! ");
					}
				
				
				}
				catch(Exception ex)
				{
				
				}
			}
			
		});
		
		
	  }
	
	
	public static void main(String[] args)
	{
		
			new Login();
			
		
	}
}